EMT Practice Test

1. Question Content...

---

Question1: Which of the following is TRUE when using a data set created with a 4 node config file?

Question2: Select the correct command to reset a password to Info1234 for user srv_etl in the Information Server internal registry, in the Unix environment.

Question3: Which statement is TRUE?

Question4: Given this score:

It runs 3 processes on 2 nodes.
How does the job run?

Question5: Assume you have before and after data sets and want to identify and process all of the changes between the two data sets. Assuming data is properly partitioned and sorted, which of the following should be used?

Question6: Which of the following locations will allow you to obtain a job's runtime logs? (Choose two.)

Question7: When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

Question8: Your job aggregates data before writing the results out to a DB2 table. You have since learned that this job will be required to aggregate very large amounts of data. To ensure high performance you create a new, non-default configuration file for the job that defines a node pool named "highperfnodes" that includes only nodes with very high processing power.
What additional design changes do you need to make to the job to ensure that it aggregates the data using the "highperfnodes" pool? (Choose two.)

Question9: Which stages will require a schema file when runtime column propagation (RCP) is enabled? (Choose two.)

Question10: How do you create a shared table definition from the DataStage client?

Question11: Which restructure stage has a single reject link?

Question12: Archive files can contain assets from multiple exports of multiple tools. When importing into a project from an archive file with the istool command, which order of asset types below would yield the best performance?

Question13: Which statement about restartable sequence jobs is TRUE?

Question14: Which is NOT a valid native operator for OSH?

Question15: Which of the following are valid stage options for a parallel DataStage job which uses a configuration file with multiple nodes and a File Connector as a source running in parallel mode? (Choose two.)

Question16: For very large records, you may need to set the following environment variable with an appropriate value in order to allow the job to run successfully:

Question17: In order to collect operational metadata, you must do which of the following?

Question18: Which of the following will determine the running row number within a group?

Question19: Which statement about the ISD input stage is NOT TRUE?

Question20: Parallel job column definitions have an SQL type associated with them. Which of the following is TRUE?

Question21: Which of the following is the default data type for the Aggregator stage during calculation?

Question22: In the Masking Policy Editor in the Data Masking stage of your job, you have specified for a column containing credit card numbers the Random Replacement masking policy. For the Copy option you have specified "(1,2)(3,4)".
What changes will be made to a credit card number, such as 6327664369, to mask it?

Question23: Given this configuration file:

Which of the following describes the resulting behavior for a job consisting of Row Generator -> data set?

Question24: Which of the following is the correct schema format for a Time column?

Question25: Consider a customer with multiple environments, Development, Test and Production. Which statement is TRUE?

Question26: By default, how much internal memory does the Sort use per partition?

Question27: You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job.
What steps should you take to understand the job performance issues? (Choose two.)

Question28: Which of the following will run the DataStage job in the Unix environment for the domain is1:9445, server is1 for the user srv_etl?

Question29: Which statement about looping in sequences is TRUE?

Question30: Which one of the following is NOT an XML Pack stage?

Question31: Which one of the following stages requires a schema file when using Runtime Column Propagation?

Question32: Which of the following is NOT a valid use of stage variables?

Question33: A Parameter Set is a named object that can contain which of the following?

Question34: Which of the following is TRUE about Transformer Stage when $APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING is set?

Question35: Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage.
The following two Balanced Optimizer options have been selected:
-Push processing to data sources -Push processing to data targets
The following two Balanced Optimizer options have NOT been selected:
-Push data reduction processing to data targets -Push all processing into the(target)data server Assuming the job design allows for maximum optimization, what does the optimized job design look like?

Question36: Which of the following actions are available when editing a message handler?

Question37: The encrypt.sh or the encrypt.bat script can be used to do which of the following?

Question38: Which statement is TRUE about Balanced Optimization?

Question39: In order to use Cognos TM1 Connector, which statement is TRUE?

Question40: A job consist of Sequential File Stage -> Copy Stage using auto partitioning -> Sequential File stage. We need the target Sequential File stage rows to be in the same order as the source file. Which collection algorithm should be chosen in the target Sequential File stage?

Question41: Which of the following environment variables can help in verifying whether data is evenly partitioned across all nodes?

Question42: Which statement about shared containers is TRUE?

Question43: When you read or write to a sequential file, and wish to have a value be identified with DataStage as NULL, which of the following is the correct option?

Question44: Which of the following statements about checkpoint/restart is TRUE?

Question45: Which of the following is TRUE?

Question46: What COBOL data type is defined by Decimal data within the Complex Flat File stage?

Question47: The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

Question48: In your project there is a top level Sequencer job which has multiple sub sequencers and jobs. You have to move this Sequencer job to a new project. How do you determine which objects have to be exported?

Question49: Which of the following is NOT TRUE about the DataStage job score?

Question50: Which client Tool is used to export environment variables from a Project?

Question51: Which of the following is TRUE about working with assets and artifacts?

Question52: Which type of data can be extracted using the Unstructured Data stage?

Question53: Which partitioning method requires a key?

Question54: Which Connector Stage doesn't support reject Link

Question55: Which of the following statements about real time job design is TRUE?

Question56: Record Count property is set to zero in Connector stage. How many rows are written out?

Question57: You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a Remove Duplicates stage. How can this be accomplished?

Question58: Which Slowly Changing Dimension (SCD) stage statement is TRUE?

Question59: Which of the following is an FTP Collection method?

Question60: To run multiple copies of the same job within Director, which of the following must be supplied?

Question61: A job is designed with 3 Join stages in sequence.
Join_1 keys are "Account", "Customer" and "PO_Date"
Join_2 keys are "Account", "Customer" and "Txn" Join_3 keys are "Account", "Product_CD" and "Txn"
Which of the following will lead to the best run time performance?

Question62: What is the primary advantage of creating data rules within Information Analyzer as opposed to creating them within the Data Rules stage?

Question63: The APT_SubProcessOperator is used for what purpose?

Question64: Which one of the following is an implicit data type conversion?